Problem
When you try to restore the iMIS database, SQL Server reports that the database is locked and cannot be restored.
Solution
Before restoring the iMIS database, ensure that all ASI services are stopped on every host that contains an instance of the application server or public website. If these services are running, SQL Server considers the database locked. The ASI services are:
■ AsiWorkflow15
■ AsiPublishing15
After restoring the database, restart all ASI services (and configure them for automatic startup).
Caution! If you changed the name of the database during the restore (such as restored from a different database), you must run DB Maintenance and select the Prepare iMIS Database function; if you do not, users will not be able to log in.